<html>

<head>
<title>SQL Relay - Getting Started With Sybase - Initializing an 11.0.3.3 Server</title>
<link rel="stylesheet" href="../../css/styles.css">
</head>

<body>

<span class="heading1">Initializing an 11.0.3.3 Server</span><br>


<p>After installing Sybase Adaptive Server Enterprise, you can initialize the 
server by following these steps.</p>

<p>First, <i>su</i> to the sybase user using the -l option.</p>

<blockquote>
<b>su -l sybase</b>
</blockquote>

<p>Run <b>install/sybinit</b>, a text-based installation program.  When
prompted, follow these instructions.</p>

<blockquote>
select <b>3. Configure a Server product</b><br>
select <b>1. SQL Server</b><br>
select <b>1. Configure a new Adaptive Server</b><br>
type ctrl-a to accept the default server name<br>
<br>
select <b>1. CONFIGURE SERVER'S INTERFACES FILE ENTRY</b><br>
select <b>3. Add a new listener service</b><br>
don't modify the default hostname/address<br>
select <b>2. Port:</b><br>
enter 4100<br>
type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Is this information correct?</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Write the changes to the interfaces file now?</b><br>
<br>
select <b>2. MASTER DEVICE CONFIGURATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
Press <return> to continue, ignoring all WARNING's.
<br>
select <b>3. SYBSYSTEMPROCS DATABASE CONFIGURATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>4. SET ERRORLOG LOCATION</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>5. CONFIGURE DEFAULT BACKUP SERVER</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>6. CONFIGURE LANGUAGES</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>7. CONFIGURE CHARACTER SETS</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>8. CONFIGURE SORT ORDER</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
select <b>9. CONFIGURE AUDITING</b><br>
type ctrl-a to <b>Accept and Continue</b><br>
<br>
on the <b>SYBASE SERVER CONFIGURATION</b> screen, type ctrl-a to <b>Accept and Continue</b><br>
type y when prompted with <b>Execute the Sybase Server Configuration now?</b><br>
Press &lt;return&gt; to continue, ignoring all WARNING's.
<br>
</blockquote>

<p>If all goes well, you should see several <b>Running task:</b> and 
<b>Task succeeded:</b> messages.  When you get a <b>Configuration completed 
successfully</b> message, press &lt;return&gt; to continue.</p>

<blockquote>
type ctrl-x to <b>Exit Screen</b><br>
type ctrl-x to <b>Exit Screen</b><br>
type ctrl-x to <b>Exit Screen</b><br>
</blockquote>

<span class="heading2">Starting the Database at Boot Time</span><br>

<p>Replace <i>/usr/local/sybase</i> with whatever directory Sybase ASE is
installed in.</p>

<blockquote>
<PRE>
<FONT color=#0000ff>#!/bin/sh</FONT>

<B><FONT color=#a62828>export </FONT></B><FONT color=#008a8e>SYBASE</FONT><B><FONT color=#a62828>=</FONT></B>/usr/local/sybase</FONT>

<B><FONT color=#a62828>export </FONT></B><FONT color=#008a8e>PATH</FONT><B><FONT color=#a62828>=</FONT></B><FONT color=#a620f7>$PATH</FONT>:<FONT color=#a620f7>$SYBASE</FONT>/bin:<FONT color=#a620f7>$SYBASE</FONT>/install

<B><FONT color=#a62828>case</FONT></B> &quot;$1&quot; <B><FONT color=#a62828>in</FONT></B>
        start<B><FONT color=#a62828>)</FONT></B>
                <B><FONT color=#a62828>for</FONT></B> i <B><FONT color=#a62828>in</FONT></B> <FONT color=#6959cf>`ls </FONT><FONT color=#a620f7>$SYBASE</FONT><FONT color=#6959cf>/install/RUN_*`</FONT>
                <B><FONT color=#a62828>do</FONT></B>
                        su <B><FONT color=#a62828>-c</FONT></B> <B><FONT color=#a62828>&quot;</FONT></B><FONT color=#ff00ff>startserver -f </FONT><FONT color=#a620f7>$i</FONT><B><FONT color=#a62828>&quot;</FONT></B> sybase <B><FONT color=#a62828>&gt;</FONT></B> /dev/null <B><FONT color=#a62828>2&gt;&amp;1</FONT></B><B><FONT color=#a62828>;</FONT></B>
                <B><FONT color=#a62828>done</FONT></B>
                <B><FONT color=#a62828>;;</FONT></B>
        stop<B><FONT color=#a62828>)</FONT></B>
                <B><FONT color=#a62828>kill</FONT></B> <FONT color=#6959cf>`ps </FONT><FONT color=#6959cf>-efa</FONT><FONT color=#6959cf> </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> grep sybase </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> grep </FONT><FONT color=#6959cf>-v</FONT><FONT color=#6959cf> grep </FONT><B><FONT color=#a62828>|</FONT></B><FONT color=#6959cf> awk </FONT><B><FONT color=#a62828>'</FONT></B><FONT color=#ff00ff>{print $2}</FONT><B><FONT color=#a62828>'</FONT></B><FONT color=#6959cf>`</FONT>
                <B><FONT color=#a62828>;;</FONT></B>
        *<B><FONT color=#a62828>)</FONT></B>
                <B><FONT color=#a62828>echo</FONT></B><FONT color=#ff00ff> $</FONT><B><FONT color=#a62828>&quot;</FONT></B><FONT color=#ff00ff>Usage: </FONT><FONT color=#a620f7>$0</FONT><FONT color=#ff00ff> {start|stop}</FONT><B><FONT color=#a62828>&quot;</FONT></B>
                <B><FONT color=#a62828>exit</FONT></B> <FONT color=#ff00ff>1</FONT>
<B><FONT color=#a62828>esac</FONT></B>

<B><FONT color=#a62828>exit</FONT></B> <FONT color=#ff00ff>0</FONT>
</PRE>
</blockquote>

<p>Install this script and run it with the "start" option to start up the
database.  Running it with the "stop" option shuts the database down.  To
access a database, it must be running.</p>

</body>

</html>
